UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HPuIUwoKx1x/6J635mVdyfIt+VBWXBhas+UeWIw+mOA='
WHERE
key_id = 'ae90ca27364e56789020429e2613321a3b28963c22d06f002adcf17cf4fb1a90'
AND (
token = 'HPuIUwoKx1x/6J635mVdyfIt+VBWXBhas+UeWIw+mOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)