UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7s0B+3hTKvcCQLydfu3HURF0xZacG0ioSrbb0dCjxig='
WHERE
key_id = '2d209c54340958deaa0628ad468485dd8f5375d77d009e1f08c7014becbf850d'
AND (
token = '7s0B+3hTKvcCQLydfu3HURF0xZacG0ioSrbb0dCjxig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)