UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N5JeA5EXGdI6R85aFS0VwDvZl8GJBLnKtgUU26fmFGw='
WHERE
key_id = 'c82bd9385eb14d1a26ac43b8f639e0efecea7b66c15f67bd95af82cb35037722'
AND (
token = 'N5JeA5EXGdI6R85aFS0VwDvZl8GJBLnKtgUU26fmFGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)