UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DK7hBrBgYcJNrWO+3lB+wpbcCtKrTkznUiwr3RnGDj0='
WHERE
key_id = '1599917dbcb3dfbe84b3f8194607f132dfe7489476fe41ec4459e899f234ff95'
AND (
token = 'DK7hBrBgYcJNrWO+3lB+wpbcCtKrTkznUiwr3RnGDj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)