UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lIZBixX9lE3y3vEq7mUNVD9F6BX1rVeBeKjJRw3M3ls='
WHERE
key_id = '54412ac4ee074ecf2babb2a2133577f5c778e65ca76c1f1fb2c54c5f5d893309'
AND (
token = 'lIZBixX9lE3y3vEq7mUNVD9F6BX1rVeBeKjJRw3M3ls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)