UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQQOAOz6xflwPnJQg+G0d6quwf3j9OS5ofTDP054TUs='
WHERE
key_id = 'e4427109f2f524b05924f1659345a38b22fa95c8afafaa0b5d9561492664b98c'
AND (
token = 'gQQOAOz6xflwPnJQg+G0d6quwf3j9OS5ofTDP054TUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)