UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4uTeHsTkpvzX7mrsQwX50c0dp0Shn3oY4EB4ymclCPs='
WHERE
key_id = '832bdb5234b7db2fcd96ce81dfc41119864c32cc7a94c09d0ae61b20e6a67cdf'
AND (
token = '4uTeHsTkpvzX7mrsQwX50c0dp0Shn3oY4EB4ymclCPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)