UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BG7FWfRvdQ6Ab0lJycGe3VeBUocNZddRU1z0eNI994I='
WHERE
key_id = 'e1db9fad0c5cdf1bf605ba9eb9875ce680738e5126c0bef6315e1445b9c4a93a'
AND (
token = 'BG7FWfRvdQ6Ab0lJycGe3VeBUocNZddRU1z0eNI994I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)