UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZE4BKAHaSbC/cpbs4CU1U3xsJz8/GTW5uxY47bBOX8='
WHERE
key_id = 'd56163a109a410d7ecbbee11a3eef926d3269d87573198b77c0bcffc242bc7ce'
AND (
token = 'XZE4BKAHaSbC/cpbs4CU1U3xsJz8/GTW5uxY47bBOX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)