UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zoCrpX42Lw812XT50+Va8ickhh72c4E+TDK0z4bi8Rw='
WHERE
key_id = '8413a977373f2a1618cb99f0b4a82a370476ebd73862958413c03874481f9020'
AND (
token = 'zoCrpX42Lw812XT50+Va8ickhh72c4E+TDK0z4bi8Rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)