UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xVhWfMrfOP+3HmcIJvq4mp9SKUUs/bI1ptpn1ir8X4E='
WHERE
key_id = '398ceaa628d2299febf5576260378a43e03fce07ee197cab93858b1326e2ce89'
AND (
token = 'xVhWfMrfOP+3HmcIJvq4mp9SKUUs/bI1ptpn1ir8X4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)