UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6DpmwUtC6wmtWQ44i9WEjwxFqHd6J4vHkakPPsmLSbM='
WHERE
key_id = '0d9d1bcdc4adc5b951d825091b51e32314199adda67851a6e41480dd5d1c0801'
AND (
token = '6DpmwUtC6wmtWQ44i9WEjwxFqHd6J4vHkakPPsmLSbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)