UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NQWalwpMOuZPmTZgAJSYDQCaJcVs2/wv0JmOHOCRkaA='
WHERE
key_id = '0509813b314649ccf4928fa6dcc5220072abad2c2210d23e53b4df8f9979ba73'
AND (
token = 'NQWalwpMOuZPmTZgAJSYDQCaJcVs2/wv0JmOHOCRkaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)