UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g1GtLGmO4ZLpnZcuK9AxwikQaLINxXbmoLctw8h5x0U='
WHERE
key_id = '6599b78105245580dea9025b9d7c48c95fb8c82b274b009fcbcd33a230177a5f'
AND (
token = 'g1GtLGmO4ZLpnZcuK9AxwikQaLINxXbmoLctw8h5x0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)