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