UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AvGQlWQKjqlTiivOu+AMzakoCpzbJ4WLbi09Gi/quOs='
WHERE
key_id = 'b988da2aa5888ff17c739f5894df513bff00a9dc5215e299294e5316cd5b96f9'
AND (
token = 'AvGQlWQKjqlTiivOu+AMzakoCpzbJ4WLbi09Gi/quOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)