UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6C58XkTS7av9+1cDJHa0IIXqpxUkZeC+mm5+sKun0is='
WHERE
key_id = 'aadb5e842049b0129458dafcd274b872eec20b8921035d211d029ae7887cdf04'
AND (
token = '6C58XkTS7av9+1cDJHa0IIXqpxUkZeC+mm5+sKun0is='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)