UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nu6aVPIulp3HnLIWVRpFsL0gO+p1/cWzSTD7jEXujMg='
WHERE
key_id = '16e2d33b5545fe7ba6401632fa8b09ac50a823ed9e927004ffcb1159e4fb0be5'
AND (
token = 'nu6aVPIulp3HnLIWVRpFsL0gO+p1/cWzSTD7jEXujMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)