UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '00J7+3UCeongDGVnSybE/aOBz1B19J87Vcp05CZDwVE='
WHERE
key_id = 'd7cd43311fe9b78ee9743117517820c03ea8f0adb24fe5bcb56c1aa056798643'
AND (
token = '00J7+3UCeongDGVnSybE/aOBz1B19J87Vcp05CZDwVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)