UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+sKja6F8WhHZ9BhYQIckyn7AG9wMlUfKUBQ/Pnm7WhA='
WHERE
key_id = 'f4a8dc968d08fc3589540280f3b0d02af98845d444f2c68912f0c08b836432e4'
AND (
token = '+sKja6F8WhHZ9BhYQIckyn7AG9wMlUfKUBQ/Pnm7WhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)