UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6krB4ExN2oDQ7InVZimLO8bPqohI7wKHlPhbalClrpQ='
WHERE
key_id = '6516e081a74b543ea46fdd8f7058bacfe347a8ffcb61a27efc139d3d296ce509'
AND (
token = '6krB4ExN2oDQ7InVZimLO8bPqohI7wKHlPhbalClrpQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)