UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zi4B2qOcqGyJ+p38TpmPC3f4NBTkwvnVi3kK6As4Hws='
WHERE
key_id = 'a364f3dae847af17b07d8770b6bd77bc1079c048c497f5b3dc0af17f0c6681e1'
AND (
token = 'zi4B2qOcqGyJ+p38TpmPC3f4NBTkwvnVi3kK6As4Hws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)