UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7sczc8PSKRD9E0RPCxf/mcegNqPKoV+d57aCrHJd0Ic='
WHERE
key_id = 'b25af816b857343afb00d96bd218f1e314cee34cb073d1bb8784f52eda68bb3e'
AND (
token = '7sczc8PSKRD9E0RPCxf/mcegNqPKoV+d57aCrHJd0Ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)