UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B7JWBmOdth1mM1HFAwbtSJcFru0gdEg9S2yWi15nC34='
WHERE
key_id = '433e9e08e99aef6d39a18f8a0517bdef5745578967d78fcb048a6b684fa72c55'
AND (
token = 'B7JWBmOdth1mM1HFAwbtSJcFru0gdEg9S2yWi15nC34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)