UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AFJpnQtkRGGRTyfMl3wG9DFiXYqvR8eG2bkC16JTDcQ='
WHERE
key_id = 'c5494502b556f12f96004a1959274cf2f61fd9cfdca757a0902449dab77250c8'
AND (
token = 'AFJpnQtkRGGRTyfMl3wG9DFiXYqvR8eG2bkC16JTDcQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)