UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W97YYuGEY8hCuv7Pi1tRJHP/7TS1LqUT3OwSTu11PmQ='
WHERE
key_id = '2ca5b71a91c5baa05a90cf2df2a50e0371106e3f974ce3c33c8dbface7f0b70f'
AND (
token = 'W97YYuGEY8hCuv7Pi1tRJHP/7TS1LqUT3OwSTu11PmQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)