UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7H72N9PpVTpio33mR9sEt1uCRh+6fGEX+7Mw/8Qiji4='
WHERE
key_id = '31faf667d9701eac50d2d894a9af835f634cc0df0d271bda8afcdb49826da66f'
AND (
token = '7H72N9PpVTpio33mR9sEt1uCRh+6fGEX+7Mw/8Qiji4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)