UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPnwRw8ipkg3p1if+GNJ9aBF4Gg264HcZ2PK3YMWv3w='
WHERE
key_id = '592c17af99d0f2a193ecdd4da2d0ded4e864d12946fee0e57b9bbcd08c917216'
AND (
token = 'zPnwRw8ipkg3p1if+GNJ9aBF4Gg264HcZ2PK3YMWv3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)