UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hKAbwNVaoBl1ll5vE0a2PsfnJEj2//To/gBerNLDXY='
WHERE
key_id = 'cf861aef339a9c35168d33a934a676d1f4e264967d9f9e5cc3cdf8c91d8231dc'
AND (
token = '1hKAbwNVaoBl1ll5vE0a2PsfnJEj2//To/gBerNLDXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)