UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8SsyvjPFkKhavm6KTzCA8r8xOJuY60L6kNMtaf5q6Uo='
WHERE
key_id = 'a3a6e522ab369c4ecccd6aba0b78dc305bf0fe11eb6660299af217e8d2ae33ed'
AND (
token = '8SsyvjPFkKhavm6KTzCA8r8xOJuY60L6kNMtaf5q6Uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)