UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vUcVX5xUuTbqqjSfDxszXJ4BmtNHbd9ainSFjBKpRX4='
WHERE
key_id = '0bc5f9005b836113f8480c9e4ad8fb7837c7877720ef82f2f4f6b91fb5b7fca6'
AND (
token = 'vUcVX5xUuTbqqjSfDxszXJ4BmtNHbd9ainSFjBKpRX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)