UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sf8vEcdZZy/mZBSoMyZiyAsWyaStXda3mCUXPq5Vu9s='
WHERE
key_id = '348b8ceb52c5608f447052b528f0cf3155ef8ebc1c099e0612aa1804db1bd9b5'
AND (
token = 'sf8vEcdZZy/mZBSoMyZiyAsWyaStXda3mCUXPq5Vu9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)