UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VsKS71Zo0sy1psF1TXg7w9wiOmbYQJWnoYl5aQDoaBw='
WHERE
key_id = '7e698d6149ee6c845cc226430a5abfc9d88403df73f5ae9a44777831daab82f3'
AND (
token = 'VsKS71Zo0sy1psF1TXg7w9wiOmbYQJWnoYl5aQDoaBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)