UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9/iKJRySXuyoqSqTOEOJeGARwN1hVO8zmjTcEznrxs='
WHERE
key_id = '167d229c23e04d5150a3ac65879db41b2366783b95e62e7654b2c1f0a7b033ca'
AND (
token = 'H9/iKJRySXuyoqSqTOEOJeGARwN1hVO8zmjTcEznrxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)