UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1tGXezb9+5zglRSaWT6fIPRUCwJbCymNLPgBBf6muYg='
WHERE
key_id = 'a18f5e0b2678c9588be095c8ba8a345ad1fdd0c8a7ec8688710fe788899d1488'
AND (
token = '1tGXezb9+5zglRSaWT6fIPRUCwJbCymNLPgBBf6muYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)