UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JE7Zzn5iOoRHhRz4BhhTQgTl1fEIr3KNj/Qrr0Pv85M='
WHERE
key_id = 'c90f1e2603a9b772925b2d09a1d9ed4cdf15d222f85d32c7e9143f3bf2d2c7e5'
AND (
token = 'JE7Zzn5iOoRHhRz4BhhTQgTl1fEIr3KNj/Qrr0Pv85M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)